CustomerCorrespondence

Entity Definition

Logical Name : CustomerCorrespondence
Physical Name : DO_CRSP_CT

An e-mail, letter, telegram, or other written communication from a CUSTOMER.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerCorrespondenceReceivedDate (PK) The date and time that a CUSTOMER's letter, fax, e-mail, or phone call is taken or received at a retail store or other facility. DC_CRSP_CT_RCV DateCalendar date
CustomerID (FK)(PK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
SendDate The date and time that a CUSTOMER's letter, fax, e-mail, or phone call was sent by the customer. DC_CRSP_CT_SND DateCalendar date
CreatedDate The date and time that a CUSTOMER's letter, fax, or e-mail was created. DC_CRSP_CT_CRT DateCalendar date
SummaryDescription A brief interpretation summarizing the main points of the correspondence. DE_CRSP_CT_SMY DescriptionNarrative varchar(4000)
ChannelID (FK) Token Identifier for a channel instance ID_CHNL Identity integer Channel(CO_CHNL)

Relationships

Parent Entity Verb Phrase Child Entity
Customer wrote CustomerCorrespondence
Channel is vehicle for CustomerCorrespondence

Logical Views containing CustomerCorrespondence

Logical View
Logical 10400 - Enterprise - Channels